Indexes

An index in a database lets you quickly find specific information in a table or indexed view. An index contains keys built from one or more columns in the table, or view, and pointers that map to the storage location of the specified data. You can significantly improve the performance of database queries and applications by creating well-designed indexes to support your queries. Indexes can reduce the amount of data that must be read to return the query result set. Indexes can also enforce uniqueness on the rows in a table, ensuring the data integrity of the table data.

Just simply click -> Index to open an object pane for Index. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected Index.

Create Index

To create a new index

To create a new index with modification as one of the existing index

Edit Index

To edit the existing index (manage its properties etc)

To change the name of the index

Maintain Index

To maintain an index

Delete Index

To delete an index

Achieve Index Information

To achieve an index information